2015-03-24 - 18107.200 - Spec - BI Report for Cross Company transactions #CrystalReportDevelopment #FIReports

SPECIFICATIONS

18107.100/18107.200 - Spec - BI Report for Cross Company transactions

Requirement Summary

BI report that reflects the payable amounts and receivable amounts between New Era entities.

Admin Info

Purpose
 Create BI report that reflects the payable amounts and receivable amounts between New Era entities.
Requested By
 Jingsha Brennan
Spec Created By
 Raghav/Dhananjay G
Spec Created Date
 03/24/2015
Spec QA by
 Uday Kumar P
Objects
 Intercompany Transactions Report
Document Status
 Complete

Estimates

SNo
 Activity
 Estimation in Hours
1
 Research
 16
2
 Documentation
 08
3
 Development/ Config
 48
4
 Unit test
 08
5
 Unit test in QUA
 00
6
 Other activity
 00

TOTAL
 80

References

Prior Tickets

18107.100

Documents

None

Spec Changes

SNo
 Change Details
 Requested By
 Requested On
 Notes if any










Functional Requirement

Purpose/WHY:

Inter company transaction report that reflects for the payable amounts and receivable amounts between New Era entities.

Reports should have the following fields:
Company Code, G/L Account, Trading Partner, Document Number, Reference, Posting Date, Amount in loc.curr.2, Local currency 2, Amount, Local Currency, Offsetting Acct, Account Description, Vendor# and Vendor Description.

In Scope:

Need to create Inter company transaction report that reflects for the payable amounts and receivable amounts between New Era entities.

Out of Scope:

None

Solution Summary

1. Report should consist the header fields mentioned below:
  1. Company Code - From Table BSEG-BUKRS.
  2. G/L Account - Input GL account to search from BSEG-HKONT Table.
  3. Trading Partner - Should display as per the document number BSEG-VBUND.
  4. Document Number - Documents as per the GL accounts in BSEG-BELNR Table.
  5. Reference - With the document number in BKPF-XBLNR.
  6. Posting Date - With the document number in BKPF-BUDAT.
  7. Amount in loc. curr.2 - Display from Table BSEG-DMBE2.
  8. Local currency 2 - Display from table BKPF-HWAE2.
  9. Amount - Display from table BSEG-DMBTR.
  10. Local Currency - Display from table BKPF-HWAER.
  11. Offsetting Acct - Should display reverse GL account, for example:- if input GL account document number line item is debit then offsetting account should be credit GL account. For this need to create alias BSEG_1 table and take the field BSEG_1-HKONT.
  12. Account Description - Should be offsetting GL account description from table SKAT-TXT20.
  13. Vendor - Vendor number should display from BSEG_1-LIFNR.
  14. Vendor Description - Display from table LFA1-NAME1.
2. Need to use the tables BSEG, BSEG_1, BKPF, SKAT and LFA1.
3. Need to input the parameters 'GL Account', 'Company Code', 'Fiscal Year' & 'Posting Period' to execute the reports.
4. Need to filter the data using following conditions from SKAT table: {SKAT_1.KTOPL} = "0010".
5. Need to check & follow NEC standards while modifying the report.

Crystal Reports Test Plan

Test ID
 Test Scenario
 Expected Results
1
 Report Format.
 Should be as per NEC crystal standard checklist.
2
 Execute Crystal Report in Crystal Designer tool after changes.
 Report should execute successfully in Crystal Designer tool.
3
 Schedule the Report in NEC BI Launch Pad.
 Report should execute successfully in NEC BI Launch Pad.

Solution Details

Here is the complete design for Intercompany Transactions report:
  1. Fields in the report:
    1. Company Code - From Table BSEG-BUKRS.
    2. G/L Account - Input GL account to search from BSEG-HKONT Table.
    3. Trading Partner - Should display as per the document number BSEG-VBUND.
    4. Document Number - Documents as per the GL accounts in BSEG-BELNR Table.
    5. Reference - With the document number in BKPF-XBLNR.
    6. Posting Date - With the document number in BKPF-BUDAT.
    7. Amount in loc. curr.2 - Display from Table BSEG-DMBE2.
    8. Local currency 2 - Display from table BKPF-HWAE2.
    9. Amount - Display from table BSEG-DMBTR.
    10. Local Currency - Display from table BKPF-HWAER.
    11. Offsetting Acct - Should display reverse GL account, for example:- if input GL account document number line item is debit then offsetting account should be credit GL account. For this need to create alias BSEG_1 table and take the field BSEG_1-HKONT.
    12. Account Description - Should be offsetting GL account description from table SKAT-TXT20.
    13. Vendor - Vendor number should display from BSEG_1-LIFNR.
    14. Vendor Description - Display from table LFA1-NAME1.
  2. Key figures for input parameters in the report:
    1. GL Account - BSEG-HKONT.
    2. Company Code - BSEG-BUKRS.
    3. Fiscal Year - BSEG-GJAHR.
    4. Posting Period - BKPF-MONT.



Inter-company Transaction Report.
InterCompany Transactions Report - P42015.xls

Issues

None